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