UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vz4QVGiQNUKJW98d4uUz2tP/EbqbJWTwh7gnL2ZGdzI='
WHERE
key_id = 'c7835efb1a2e07836aee8759460f652a7cbe3c9f9ef8770b11b9fec13ef93dee'
AND (
token = 'Vz4QVGiQNUKJW98d4uUz2tP/EbqbJWTwh7gnL2ZGdzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)