UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XjYsMd8RZfWrKtxwPQhu7FdL7O5RcaJkHsEhE8iwiyk='
WHERE
key_id = '49b4adf4e14a7deb76e8f4cbb85037b44422a6214dfe433b3f94cf004c980b33'
AND (
token = 'XjYsMd8RZfWrKtxwPQhu7FdL7O5RcaJkHsEhE8iwiyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)