UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CcrKgyV1xMOLw8ymjljE0kv0ojC+B/ofvZ66GheGmew='
WHERE
key_id = 'c6d1d6a97dc752ba77b03533a6e067e2a681d48cb26c83f1854acc4101fb29f3'
AND (
token = 'CcrKgyV1xMOLw8ymjljE0kv0ojC+B/ofvZ66GheGmew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)