UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkf0siAGHEXTeVV3wJq0XycA8aWLwTX93B3J6gCqSLg='
WHERE
key_id = '465ffb471b3515d1e8c2e793b5250384ac1caae8e083bfad85db5250d919bb29'
AND (
token = 'pkf0siAGHEXTeVV3wJq0XycA8aWLwTX93B3J6gCqSLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)