UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hyTn9+KT9SBt36SZj1IHJJ+o04h8SpOhSgI/tjScX4g='
WHERE
key_id = 'd2e998c2aa4aebafda6f1337541a0b1ab890e3404fef5f4808520a91ba3071cb'
AND (
token = 'hyTn9+KT9SBt36SZj1IHJJ+o04h8SpOhSgI/tjScX4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)