UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bMcP5Cb3epdngCL2EtuEk0T8ur/t0kF8nUc7nA8SlaA='
WHERE
key_id = '9b93423a3f1d4a5290e9a6c5b17e36b57503fa377357e99a93b5eea897549fd0'
AND (
token = 'bMcP5Cb3epdngCL2EtuEk0T8ur/t0kF8nUc7nA8SlaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)