UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xLVLpbpQmLw9lvMYlDpNiMZAMIvh1phkCrKf30FfZn8='
WHERE
key_id = 'cc576a65906a4ded6a49f35e3113c8d85492f80c36172f20408683c12a4a9324'
AND (
token = 'xLVLpbpQmLw9lvMYlDpNiMZAMIvh1phkCrKf30FfZn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)