UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L/9iY2J023VVJmYWkfwsvOcvF/RpLOPh68cUuZ4k7LM='
WHERE
key_id = '6c97384587d22fc19404012ddb284a92166eceeaf616419ec3ce78e720be397d'
AND (
token = 'L/9iY2J023VVJmYWkfwsvOcvF/RpLOPh68cUuZ4k7LM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)