UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gZtpJyReJ9a80oPVrvHpW2iYfNuUnByY4OsvURzzlyU='
WHERE
key_id = '1b1f6bbc1a6f0dd73dc06ab7e5bb7a08f44a4a0d012cba9944f82f588ef47177'
AND (
token = 'gZtpJyReJ9a80oPVrvHpW2iYfNuUnByY4OsvURzzlyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)