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