UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Ksd0LLfPWm6iE5HmRfAQ6efP7itps+Wo54UmfnXj5w='
WHERE
key_id = '3c308ef2de6b176e9f460082f4cad41989c343b7743200ba1e45dc1843b14526'
AND (
token = '9Ksd0LLfPWm6iE5HmRfAQ6efP7itps+Wo54UmfnXj5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)