UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YWaIfMqL4nFF6T4jEvInaxt9G+IHNYSf3Bc/40W9Swk='
WHERE
key_id = '4077c3d8e8130f37c5cb224b16d4687481dcf37f940e5bd508c18a8a15d38a8c'
AND (
token = 'YWaIfMqL4nFF6T4jEvInaxt9G+IHNYSf3Bc/40W9Swk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)