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