UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zx4LsLgsxaGCuAIC++W3YIHsed1U48rHXn46eouVVoU='
WHERE
key_id = '4018217fa468a1f6732b989b752db8605963eddc0740936b6f19e46434fd3c3c'
AND (
token = 'Zx4LsLgsxaGCuAIC++W3YIHsed1U48rHXn46eouVVoU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)