UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/4dEArTIf7c/ZAAgeCP3ZlKnZe5qLU1pX35767V8L8o='
WHERE
key_id = 'b110b1ee54728c20631053d3df7d51e8c3c7b1663caa94c3fa2fdfce685612bc'
AND (
token = '/4dEArTIf7c/ZAAgeCP3ZlKnZe5qLU1pX35767V8L8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)