UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kH4P7sKz7i0z1lL4tz4jgZx+IvhBfUGrsElNRSmiF20='
WHERE
key_id = 'a80092abcda2974e76b6d00bded240950a21bda95587c3fc3b0c4ca677a65927'
AND (
token = 'kH4P7sKz7i0z1lL4tz4jgZx+IvhBfUGrsElNRSmiF20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)