UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEhLW3M+y4eZZMmRtuM3aXqrg2d5YvBLqMXm5eW2cWI='
WHERE
key_id = '89097a945375b4db6464d15223f055ea252593118fb99f0fbe61fd823aead38d'
AND (
token = 'gEhLW3M+y4eZZMmRtuM3aXqrg2d5YvBLqMXm5eW2cWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)