UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idpUCA7y7I+9zOvcUtnW7sh2QIJGW+0KS9lURD3t5yQ='
WHERE
key_id = '419a0bc6458b75b750d422bf9610e4edcdb428cfe2b560e854a961a26da40e5e'
AND (
token = 'idpUCA7y7I+9zOvcUtnW7sh2QIJGW+0KS9lURD3t5yQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)