UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qeGin7skrmfzPxh+h6/5vSuyKgoqic+e/R26dWzJvJE='
WHERE
key_id = 'f23c8d042c21a1e4bb51edb05fcfa88fa569d183a8e48d58b6811b7a7b47a832'
AND (
token = 'qeGin7skrmfzPxh+h6/5vSuyKgoqic+e/R26dWzJvJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)