UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzYqMorYxy9LZCvm5OyO6SxvE7HU+djg6c/wymt0mjM='
WHERE
key_id = '20a91407f929da508e0aa3e08745ded78659f0d67049494baf3c683f7e7ce849'
AND (
token = 'XzYqMorYxy9LZCvm5OyO6SxvE7HU+djg6c/wymt0mjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)