UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3jcqNqYu7qWAp8yO9vjRMjIuxKbZ1vi30+CLLIUNm2k='
WHERE
key_id = '3810389bd1e4f58fa013527caa182302155e1af859471c8df1585d056fe10c6d'
AND (
token = '3jcqNqYu7qWAp8yO9vjRMjIuxKbZ1vi30+CLLIUNm2k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)