UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J3b9QtjsBeEo+niUZpq4oFynrmrRTIz7knLnGs0qyHo='
WHERE
key_id = 'e8043f09d5d00065740eee40637c44c27899d54a1d12f3090be1e973a236fa0a'
AND (
token = 'J3b9QtjsBeEo+niUZpq4oFynrmrRTIz7knLnGs0qyHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)