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