UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X7hleuDCfO5cW9+w9DaAo3QBX0e4iEFVpp++qRYpR04=' 
WHERE 
  key_id = 'b9d8a2303f4e0f09f9fa36b29619fe8a99ae27f321452e08703fff08e910b7bd' 
  AND (
    token = 'X7hleuDCfO5cW9+w9DaAo3QBX0e4iEFVpp++qRYpR04=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024