UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nMdFgpujj2hEiq52pvA6brRrl8y69lCARAc0maXjoI4='
WHERE
key_id = '2c8f5563a8bd3f02495f4bf50a3b2dc190af03d5982b20e05732e132cc3ed2ed'
AND (
token = 'nMdFgpujj2hEiq52pvA6brRrl8y69lCARAc0maXjoI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)