UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NJ//4tGHZbpgvYuMWE3J7F8p6V6HG7ekXO3QRMis5TY=' 
WHERE 
  key_id = '7602e8367c58c8d01df5fb2d17cee97be15adda2136f86ea8a2a0c6c724b5e3a' 
  AND (
    token = 'NJ//4tGHZbpgvYuMWE3J7F8p6V6HG7ekXO3QRMis5TY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032