UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zYQ6fWd52IQ/VjJy08HYAaZYMKCq86bg2zehcjLfNU='
WHERE
key_id = 'ecd07c4d6ef7e9a3d9441f78469f03fc1550c761b9a65592ab7cc749f8e23f70'
AND (
token = '/zYQ6fWd52IQ/VjJy08HYAaZYMKCq86bg2zehcjLfNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)