UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xYdmMCZTIR1hpa7tjmsBPJ5EM41hQ4pXbS0DAxvGmY8='
WHERE
key_id = '536daac33daa889f81588aef7d0d3c989d668ca207c4ddd2360cf78e5e0b7294'
AND (
token = 'xYdmMCZTIR1hpa7tjmsBPJ5EM41hQ4pXbS0DAxvGmY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)