UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8mrRALroRjGf4S1FMDqIU04Jl4kZbRc5eWHD955GFlM='
WHERE
key_id = '8147f52eb5f700e3d682d0478b1539e4fac699a9f50bf636e7f46bf38cda5e9b'
AND (
token = '8mrRALroRjGf4S1FMDqIU04Jl4kZbRc5eWHD955GFlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)